Populate the staging table using SSIS. 11

Open SSIS in order to create a package to populate staging table.




Follow steps to create a data flow task. Create an Excel Source(CensusFile), and lastly an OLE DB Destination(StagingTable).


Run package and the staging table that we created should be populated.


Select Statement will show the results below:

Excel Source in SSIS-Tutorial

OLE DB Destination in SSIS-Tutorial